Access Level 3

Students will learn how to use a variety of complex database techniques.

Lesson 1: Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls

Lesson 2: Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries

Lesson 3: Macros
Creating, running, and modifying macros
Attaching macros to the events of database objects

Lesson 4: Advanced macros
Creating macros to provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer

Lesson 5: Importing, exporting, and linking objects
Importing objects
Exporting objects
Working with XML documents
Linking Access objects
Using hyperlink fields

Lesson 6: Database management
Optimizing resources
Protecting databases
Setting options and properties

Printable course details

or equivalent knowledge.

7.5 hours

Individual Tuition

Group Training

Distance Learning

Prices

Distance Learning price